<%@page import="java.sql.*"%>
<%@page import="cn.cjyll.C3P0DataSoure.JDBCUtilsC3P0"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<jsp:include page="head.jsp" />
<body class="page-body  page-fade">
<jsp:include page="nav.jsp" />

<%
        Connection con = JDBCUtilsC3P0.getConnection();
        String sql = "SELECT nr FROM gg;";
        PreparedStatement ps = con.prepareStatement(sql);
        ResultSet res = ps.executeQuery();
        while(res.next())
        {
            request.getSession().setAttribute("gg", res.getString("nr")); 
        }
         ps.close();
        con.close();
 %> 
        
              
<form action="${pageContext.request.contextPath }/ggServlet">
<center>
    公  告  内  容： <br> <br>
    ${requestScope.Msg }
    <div align="center">
    <textArea name="gg" style="text-align:center;" rows="10" placeholder="请在此输入公告信息" class="form-control" >${sessionScope.gg}</textArea>
    </div>
<br>
<input type="submit" value=" 发 布 公 告 " class="btn btn-info">
<input type="reset" value=" 重 置 内 容 " class="btn btn-info">


</center></form>
</body>


<jsp:include page="copy.jsp" />